package com.trkj.dao.jpa;

import java.util.List;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.CrudRepository;
import com.trkj.pojos.Tbdepartment;

public interface IJl_tbdepartmentDAO extends CrudRepository<Tbdepartment, Long> {

	@Query("select s from Tbdepartment s where s.king=?1")
	public List<Tbdepartment> usefindALLdepartment(String king);
	@Query("select s from Tbdepartment s ")
	public List<Tbdepartment> findALLdepartment();
	@Query("select s from Tbdepartment s where s.departmentNo=?1")
	public List<Tbdepartment> idTofindALLdepartment(Long bmid);
	@Query("select s from Tbdepartment s where s.departmentName=?1")
	public List<Tbdepartment> nameTofindALLdepartment(String departmentName);
}
